package cn.mzcode.xyzpfuwuduan.dao;

import cn.mzcode.xyzpfuwuduan.pojo.Student;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

@Mapper
public interface StudentMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(Student record);

    int insertSelective(Student record);

    Student selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(Student record);

    int updateByPrimaryKeyWithBLOBs(Student record);

    int updateByPrimaryKey(Student record);

    int checkUsername(String username);

    Student selectLogin(@Param("username") String username, @Param("md5Password") String md5Password);

    int checkPhone(String str);

    int checkEmail(String str);

    String selectPhoneByUsername(String username);

    int updateByUsername(@Param("username") String username, @Param("md5Passowrd") String md5Password);

    int checkPassword(@Param("password") String passwordOld, @Param("id") Integer id);

    int checkEmailByUserId(@Param("email") String email, @Param("id") Integer id);

    int checkPhoneByUserId(@Param("phone") String phone, @Param("id") Integer id);
}